Dataset info
| Number of variables | 45 |
|---|---|
| Number of observations | 532428 |
| Missing cells | 2380715 (9.9%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 182.8 MiB |
| Average record size in memory | 360.0 B |
Variables types
| Numeric | 24 |
|---|---|
| Categorical | 17 |
| Boolean | 2 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 2 |
| Unsupported | 0 |
Warnings
acc_now_delinq is highly skewed (γ1 = 27.64041058) | Skewed |
acc_now_delinq has 529949 (99.5%) zeros | Zeros |
addr_state has a high cardinality: 51 distinct values | Warning |
annual_inc is highly skewed (γ1 = 44.77621587) | Skewed |
batch_enrolled has a high cardinality: 105 distinct values | Warning |
batch_enrolled has 85149 (16.0%) missing values | Missing |
collection_recovery_fee is highly skewed (γ1 = 30.83826071) | Skewed |
collection_recovery_fee has 518423 (97.4%) zeros | Zeros |
collections_12_mths_ex_med has 525346 (98.7%) zeros | Zeros |
delinq_2yrs has 430104 (80.8%) zeros | Zeros |
desc has a high cardinality: 70639 distinct values | Warning |
desc has 456829 (85.8%) missing values | Missing |
emp_length has 26891 (5.1%) missing values | Missing |
emp_title has a high cardinality: 190125 distinct values | Warning |
emp_title has 30833 (5.8%) missing values | Missing |
funded_amnt_inv is highly correlated with funded_amnt (ρ = 0.9980407483) | Rejected |
inq_last_6mths has 298854 (56.1%) zeros | Zeros |
last_week_pay has a high cardinality: 98 distinct values | Warning |
loan_amnt is highly correlated with funded_amnt_inv (ρ = 0.9971235007) | Rejected |
mths_since_last_delinq has 272554 (51.2%) missing values | Missing |
mths_since_last_major_derog has 399448 (75.0%) missing values | Missing |
mths_since_last_record has 450305 (84.6%) missing values | Missing |
pub_rec has 451040 (84.7%) zeros | Zeros |
recoveries has 517723 (97.2%) zeros | Zeros |
title has a high cardinality: 39694 distinct values | Warning |
tot_coll_amt is highly skewed (γ1 = 61.64220691) | Skewed |
tot_coll_amt has 420903 (79.1%) zeros | Zeros |
tot_coll_amt has 42004 (7.9%) missing values | Missing |
tot_cur_bal has 42004 (7.9%) missing values | Missing |
total_rec_int has 10953 (2.1%) zeros | Zeros |
total_rec_late_fee has 524986 (98.6%) zeros | Zeros |
total_rev_hi_lim is highly skewed (γ1 = 77.3834345) | Skewed |
total_rev_hi_lim has 42004 (7.9%) missing values | Missing |
verification_status_joint has 532123 (99.9%) missing values | Missing |
zip_code has a high cardinality: 917 distinct values | Warning |
acc_now_delinq
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.005014913263 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros (%) | 99.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.07911680643 |
|---|---|
| Coef of variation | 15.77630605 |
| Kurtosis | 2290.336321 |
| Mean | 0.005014913263 |
| MAD | 0.009983427378 |
| Skewness | 27.64041058 |
| Sum | 2670 |
| Variance | 0.00625946906 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 529949 | 99.5% | |
| 1 | 2304 | 0.4% | |
| 2 | 134 | < 0.1% | |
| 3 | 16 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| (Missing) | 16 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 529949 | 99.5% | |
| 1 | 2304 | 0.4% | |
| 2 | 134 | < 0.1% | |
| 3 | 16 | < 0.1% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 14 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 3 | 16 | < 0.1% |
addr_state
Categorical
| Distinct count | 51 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| CA | |
|---|---|
| NY | 44406 |
| TX | 42527 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| CA | 77911 | 14.6% | |
| NY | 44406 | 8.3% | |
| TX | 42527 | 8.0% | |
| FL | 36575 | 6.9% | |
| IL | 21205 | 4.0% | |
| NJ | 20103 | 3.8% | |
| PA | 18882 | 3.5% | |
| OH | 17778 | 3.3% | |
| GA | 17292 | 3.2% | |
| VA | 15826 | 3.0% | |
| Other values (41) | 219923 | 41.3% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
annual_inc
Numeric
| Distinct count | 33989 |
|---|---|
| Unique (%) | 6.4% |
| Missing (%) | < 0.1% |
| Missing (n) | 3 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 75029.84329 |
|---|---|
| Minimum | 1200 |
| Maximum | 9500000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1200 |
|---|---|
| 5-th percentile | 28000 |
| Q1 | 45000 |
| Median | 65000 |
| Q3 | 90000 |
| 95-th percentile | 150000 |
| Maximum | 9500000 |
| Range | 9498800 |
| Interquartile range | 45000 |
Descriptive statistics
| Standard deviation | 65199.84501 |
|---|---|
| Coef of variation | 0.8689854884 |
| Kurtosis | 4815.473459 |
| Mean | 75029.84329 |
| MAD | 31746.56362 |
| Skewness | 44.77621587 |
| Sum | 3.994776431e+10 |
| Variance | 4251019790 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 60000 | 20558 | 3.9% | |
| 50000 | 18363 | 3.4% | |
| 65000 | 15420 | 2.9% | |
| 70000 | 14493 | 2.7% | |
| 40000 | 14352 | 2.7% | |
| 80000 | 13621 | 2.6% | |
| 45000 | 13589 | 2.6% | |
| 75000 | 13372 | 2.5% | |
| 55000 | 12416 | 2.3% | |
| 90000 | 10305 | 1.9% | |
| Other values (33978) | 385936 | 72.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1200 | 1 | < 0.1% | |
| 1896 | 1 | < 0.1% | |
| 2000 | 1 | < 0.1% | |
| 3000 | 2 | < 0.1% | |
| 3300 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9500000 | 1 | < 0.1% | |
| 8900060 | 1 | < 0.1% | |
| 8706582 | 1 | < 0.1% | |
| 8500021 | 1 | < 0.1% | |
| 8253000 | 1 | < 0.1% |
application_type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| INDIVIDUAL | |
|---|---|
| JOINT | 305 |
| Value | Count | Frequency (%) | |
| INDIVIDUAL | 532123 | 99.9% | |
| JOINT | 305 | 0.1% |
| Max length | 10 |
|---|---|
| Mean length | 9.997135763 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
batch_enrolled
Categorical
| Distinct count | 105 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 16.0% |
| Missing (n) | 85149 |
| BAT2252229 | 18791 |
|---|---|
| BAT3873588 | 17839 |
| Other values (101) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 106079 | 19.9% | ||
| BAT2252229 | 18791 | 3.5% | |
| BAT3873588 | 17839 | 3.4% | |
| BAT2803411 | 17111 | 3.2% | |
| BAT2078974 | 14859 | 2.8% | |
| BAT1586599 | 14463 | 2.7% | |
| BAT1780517 | 13918 | 2.6% | |
| BAT1104812 | 13505 | 2.5% | |
| BAT4694572 | 13504 | 2.5% | |
| BAT1184694 | 12251 | 2.3% | |
| Other values (94) | 204959 | 38.5% | |
| (Missing) | 85149 | 16.0% |
| Max length | 10 |
|---|---|
| Mean length | 7.069098545 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
collection_recovery_fee
Numeric
| Distinct count | 12617 |
|---|---|
| Unique (%) | 2.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.859220747 |
|---|---|
| Minimum | 0 |
| Maximum | 7002.19 |
| Zeros (%) | 97.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7002.19 |
| Range | 7002.19 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 63.1233612 |
|---|---|
| Coef of variation | 12.99042881 |
| Kurtosis | 1913.975438 |
| Mean | 4.859220747 |
| MAD | 9.482567814 |
| Skewness | 30.83826071 |
| Sum | 2587185.184 |
| Variance | 3984.558729 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 518423 | 97.4% | |
| 2 | 13 | < 0.1% | |
| 2.73 | 10 | < 0.1% | |
| 3.09 | 9 | < 0.1% | |
| 1.8 | 9 | < 0.1% | |
| 3.71 | 9 | < 0.1% | |
| 1.55 | 8 | < 0.1% | |
| 2.52 | 8 | < 0.1% | |
| 2.61 | 7 | < 0.1% | |
| 1.45 | 7 | < 0.1% | |
| Other values (12607) | 13925 | 2.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 518423 | 97.4% | |
| 0.036 | 1 | < 0.1% | |
| 0.0449999999 | 1 | < 0.1% | |
| 0.063 | 1 | < 0.1% | |
| 0.0710999972 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7002.19 | 1 | < 0.1% | |
| 6972.59 | 1 | < 0.1% | |
| 6543.04 | 1 | < 0.1% | |
| 5774.8 | 1 | < 0.1% | |
| 5694.0936 | 1 | < 0.1% |
collections_12_mths_ex_med
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 95 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01429932016 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | 98.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1330051752 |
|---|---|
| Coef of variation | 9.301503408 |
| Kurtosis | 778.8263299 |
| Mean | 0.01429932016 |
| MAD | 0.02822327622 |
| Skewness | 15.76053149 |
| Sum | 7612 |
| Variance | 0.01769037664 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 525346 | 98.7% | |
| 1 | 6494 | 1.2% | |
| 2 | 416 | 0.1% | |
| 3 | 53 | < 0.1% | |
| 4 | 15 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| (Missing) | 95 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 525346 | 98.7% | |
| 1 | 6494 | 1.2% | |
| 2 | 416 | 0.1% | |
| 3 | 53 | < 0.1% | |
| 4 | 15 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 4 | 15 | < 0.1% |
delinq_2yrs
Numeric
| Distinct count | 27 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3144482093 |
|---|---|
| Minimum | 0 |
| Maximum | 30 |
| Zeros (%) | 80.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.860044949 |
|---|---|
| Coef of variation | 2.735092532 |
| Kurtosis | 52.75034207 |
| Mean | 0.3144482093 |
| MAD | 0.5080480252 |
| Skewness | 5.373310276 |
| Sum | 167416 |
| Variance | 0.7396773143 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 430104 | 80.8% | |
| 1 | 67947 | 12.8% | |
| 2 | 20167 | 3.8% | |
| 3 | 7269 | 1.4% | |
| 4 | 3159 | 0.6% | |
| 5 | 1622 | 0.3% | |
| 6 | 898 | 0.2% | |
| 7 | 451 | 0.1% | |
| 8 | 266 | < 0.1% | |
| 9 | 166 | < 0.1% | |
| Other values (16) | 363 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 430104 | 80.8% | |
| 1 | 67947 | 12.8% | |
| 2 | 20167 | 3.8% | |
| 3 | 7269 | 1.4% | |
| 4 | 3159 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30 | 1 | < 0.1% | |
| 27 | 1 | < 0.1% | |
| 26 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% |
desc
Categorical
| Distinct count | 70639 |
|---|---|
| Unique (%) | 13.3% |
| Missing (%) | 85.8% |
| Missing (n) | 456829 |
| > Debt consolidation<br> | 576 |
|---|---|
| > Debt Consolidation<br> | 372 |
| > debt consolidation<br> | 347 |
| Other values (70635) | 74304 |
| (Missing) |
| Value | Count | Frequency (%) | |
| > Debt consolidation<br> | 576 | 0.1% | |
| > Debt Consolidation<br> | 372 | 0.1% | |
| > debt consolidation<br> | 347 | 0.1% | |
| > Debt consolidation.<br> | 131 | < 0.1% | |
| > Pay off credit cards<br> | 122 | < 0.1% | |
| > Credit card consolidation<br> | 103 | < 0.1% | |
| > pay off credit cards<br> | 101 | < 0.1% | |
| > credit card consolidation<br> | 68 | < 0.1% | |
| > Consolidation<br> | 65 | < 0.1% | |
| > To pay off credit cards<br> | 52 | < 0.1% | |
| Other values (70628) | 73662 | 13.8% | |
| (Missing) | 456829 | 85.8% |
| Max length | 3966 |
|---|---|
| Mean length | 32.08913318 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
dti
Numeric
| Distinct count | 4058 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 18.13876663 |
|---|---|
| Minimum | 0 |
| Maximum | 672.52 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5.2 |
| Q1 | 11.93 |
| Median | 17.65 |
| Q3 | 23.95 |
| 95-th percentile | 32.74 |
| Maximum | 672.52 |
| Range | 672.52 |
| Interquartile range | 12.02 |
Descriptive statistics
| Standard deviation | 8.369074218 |
|---|---|
| Coef of variation | 0.4613915813 |
| Kurtosis | 76.36353877 |
| Mean | 18.13876663 |
| MAD | 6.811434912 |
| Skewness | 1.28974002 |
| Sum | 9657587.24 |
| Variance | 70.04140327 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 14.4 | 410 | 0.1% | |
| 19.2 | 399 | 0.1% | |
| 18 | 390 | 0.1% | |
| 16.8 | 385 | 0.1% | |
| 15.6 | 380 | 0.1% | |
| 13.2 | 374 | 0.1% | |
| 12 | 355 | 0.1% | |
| 20.4 | 353 | 0.1% | |
| 21.6 | 348 | 0.1% | |
| 22.8 | 324 | 0.1% | |
| Other values (4048) | 528710 | 99.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 265 | < 0.1% | |
| 0.01 | 5 | < 0.1% | |
| 0.02 | 7 | < 0.1% | |
| 0.03 | 4 | < 0.1% | |
| 0.04 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 672.52 | 1 | < 0.1% | |
| 380.53 | 1 | < 0.1% | |
| 137.4 | 1 | < 0.1% | |
| 120.66 | 1 | < 0.1% | |
| 104 | 1 | < 0.1% |
emp_length
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 5.1% |
| Missing (n) | 26891 |
| 10+ years | |
|---|---|
| 2 years | 47276 |
| < 1 year | 42253 |
| Other values (8) |
| Value | Count | Frequency (%) | |
| 10+ years | 175105 | 32.9% | |
| 2 years | 47276 | 8.9% | |
| < 1 year | 42253 | 7.9% | |
| 3 years | 42175 | 7.9% | |
| 1 year | 34202 | 6.4% | |
| 5 years | 33393 | 6.3% | |
| 4 years | 31581 | 5.9% | |
| 7 years | 26680 | 5.0% | |
| 8 years | 26443 | 5.0% | |
| 6 years | 25741 | 4.8% | |
| (Missing) | 26891 | 5.1% |
| Max length | 9 |
|---|---|
| Mean length | 7.470856153 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
emp_title
Categorical
| Distinct count | 190125 |
|---|---|
| Unique (%) | 35.7% |
| Missing (%) | 5.8% |
| Missing (n) | 30833 |
| Teacher | 8280 |
|---|---|
| Manager | 6922 |
| Registered Nurse | 3387 |
| Other values (190121) | |
| (Missing) | 30833 |
| Value | Count | Frequency (%) | |
| Teacher | 8280 | 1.6% | |
| Manager | 6922 | 1.3% | |
| Registered Nurse | 3387 | 0.6% | |
| Owner | 3305 | 0.6% | |
| RN | 3255 | 0.6% | |
| Supervisor | 3215 | 0.6% | |
| Sales | 2668 | 0.5% | |
| Project Manager | 2473 | 0.5% | |
| Office Manager | 2189 | 0.4% | |
| Driver | 2187 | 0.4% | |
| Other values (190114) | 463714 | 87.1% | |
| (Missing) | 30833 | 5.8% |
| Max length | 75 |
|---|---|
| Mean length | 15.33395877 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
funded_amnt
Numeric
| Distinct count | 1370 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 14744.27129 |
|---|---|
| Minimum | 500 |
| Maximum | 35000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 3600 |
| Q1 | 8000 |
| Median | 13000 |
| Q3 | 20000 |
| 95-th percentile | 32000 |
| Maximum | 35000 |
| Range | 34500 |
| Interquartile range | 12000 |
Descriptive statistics
| Standard deviation | 8429.139277 |
|---|---|
| Coef of variation | 0.5716891063 |
| Kurtosis | -0.2537829808 |
| Mean | 14744.27129 |
| MAD | 6865.132918 |
| Skewness | 0.6833169317 |
| Sum | 7850262875 |
| Variance | 71050388.96 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 10000 | 37118 | 7.0% | |
| 12000 | 30069 | 5.6% | |
| 15000 | 28345 | 5.3% | |
| 20000 | 28085 | 5.3% | |
| 35000 | 21650 | 4.1% | |
| 8000 | 16656 | 3.1% | |
| 5000 | 16275 | 3.1% | |
| 6000 | 15624 | 2.9% | |
| 25000 | 14271 | 2.7% | |
| 16000 | 14165 | 2.7% | |
| Other values (1360) | 310170 | 58.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 500 | 7 | < 0.1% | |
| 550 | 1 | < 0.1% | |
| 600 | 3 | < 0.1% | |
| 700 | 3 | < 0.1% | |
| 725 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 35000 | 21650 | 4.1% | |
| 34975 | 20 | < 0.1% | |
| 34950 | 12 | < 0.1% | |
| 34925 | 5 | < 0.1% | |
| 34900 | 7 | < 0.1% |
funded_amnt_inv
Highly correlated
This variable is highly correlated with funded_amnt and should be ignored for analysis
| Correlation | 0.9980407483 |
|---|
grade
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B | |
|---|---|
| C | |
| A | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| B | 152713 | 28.7% | |
| C | 147499 | 27.7% | |
| A | 89107 | 16.7% | |
| D | 83567 | 15.7% | |
| E | 42495 | 8.0% | |
| F | 13826 | 2.6% | |
| G | 3221 | 0.6% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
home_ownership
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| MORTGAGE | |
|---|---|
| RENT | |
| OWN | 52664 |
| Other values (3) | 156 |
| Value | Count | Frequency (%) | |
| MORTGAGE | 265940 | 49.9% | |
| RENT | 213668 | 40.1% | |
| OWN | 52664 | 9.9% | |
| OTHER | 117 | < 0.1% | |
| NONE | 36 | < 0.1% | |
| ANY | 3 | < 0.1% |
| Max length | 8 |
|---|---|
| Mean length | 5.899242715 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
initial_list_status
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| f | |
|---|---|
| w |
| Value | Count | Frequency (%) | |
| f | 274018 | 51.5% | |
| w | 258410 | 48.5% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
inq_last_6mths
Numeric
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.6946030518 |
|---|---|
| Minimum | 0 |
| Maximum | 31 |
| Zeros (%) | 56.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 31 |
| Range | 31 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9970254763 |
|---|---|
| Coef of variation | 1.435388851 |
| Kurtosis | 9.833191398 |
| Mean | 0.6946030518 |
| MAD | 0.7797904647 |
| Skewness | 2.034336168 |
| Sum | 369815 |
| Variance | 0.9940598004 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 298854 | 56.1% | |
| 1 | 144735 | 27.2% | |
| 2 | 56369 | 10.6% | |
| 3 | 22548 | 4.2% | |
| 4 | 6533 | 1.2% | |
| 5 | 2397 | 0.5% | |
| 6 | 720 | 0.1% | |
| 7 | 99 | < 0.1% | |
| 8 | 79 | < 0.1% | |
| 9 | 26 | < 0.1% | |
| Other values (13) | 52 | < 0.1% | |
| (Missing) | 16 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 298854 | 56.1% | |
| 1 | 144735 | 27.2% | |
| 2 | 56369 | 10.6% | |
| 3 | 22548 | 4.2% | |
| 4 | 6533 | 1.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 31 | 1 | < 0.1% | |
| 28 | 1 | < 0.1% | |
| 24 | 2 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 18 | 2 | < 0.1% |
int_rate
Numeric
| Distinct count | 535 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.24296878 |
|---|---|
| Minimum | 5.32 |
| Maximum | 28.99 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 5.32 |
|---|---|
| 5-th percentile | 6.62 |
| Q1 | 9.99 |
| Median | 12.99 |
| Q3 | 16.2 |
| 95-th percentile | 20.99 |
| Maximum | 28.99 |
| Range | 23.67 |
| Interquartile range | 6.21 |
Descriptive statistics
| Standard deviation | 4.379611104 |
|---|---|
| Coef of variation | 0.3307121823 |
| Kurtosis | -0.1610721311 |
| Mean | 13.24296878 |
| MAD | 3.51084324 |
| Skewness | 0.4284533005 |
| Sum | 7050927.38 |
| Variance | 19.18099342 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 10.99 | 20609 | 3.9% | |
| 9.17 | 15436 | 2.9% | |
| 15.61 | 15207 | 2.9% | |
| 9.99 | 13054 | 2.5% | |
| 7.89 | 12219 | 2.3% | |
| 13.99 | 11332 | 2.1% | |
| 12.69 | 11317 | 2.1% | |
| 12.29 | 11233 | 2.1% | |
| 12.99 | 11083 | 2.1% | |
| 17.57 | 10754 | 2.0% | |
| Other values (525) | 400184 | 75.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 5.32 | 5751 | 1.1% | |
| 5.42 | 335 | 0.1% | |
| 5.79 | 240 | < 0.1% | |
| 5.93 | 1078 | 0.2% | |
| 5.99 | 193 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28.99 | 67 | < 0.1% | |
| 28.49 | 80 | < 0.1% | |
| 27.99 | 2 | < 0.1% | |
| 27.88 | 130 | < 0.1% | |
| 27.49 | 4 | < 0.1% |
last_week_pay
Categorical
| Distinct count | 98 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 13th week | 30333 |
|---|---|
| 9th week | 28626 |
| 26th week | 27475 |
| Other values (95) |
| Value | Count | Frequency (%) | |
| 13th week | 30333 | 5.7% | |
| 9th week | 28626 | 5.4% | |
| 26th week | 27475 | 5.2% | |
| 22th week | 26000 | 4.9% | |
| 4th week | 25704 | 4.8% | |
| 35th week | 24037 | 4.5% | |
| 39th week | 23796 | 4.5% | |
| 17th week | 22036 | 4.1% | |
| 31th week | 21437 | 4.0% | |
| 52th week | 19391 | 3.6% | |
| Other values (88) | 283593 | 53.3% |
| Max length | 10 |
|---|---|
| Mean length | 9.075619614 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
loan_amnt
Highly correlated
This variable is highly correlated with funded_amnt_inv and should be ignored for analysis
| Correlation | 0.9971235007 |
|---|
loan_status
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 406601 | 76.4% | |
| 1 | 125827 | 23.6% |
member_id
Numeric
| Distinct count | 532428 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 35005472.35 |
|---|---|
| Minimum | 70473 |
| Maximum | 73544841 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 70473 |
|---|---|
| 5-th percentile | 1321077 |
| Q1 | 10866882.5 |
| Median | 37095895 |
| Q3 | 58489200.75 |
| 95-th percentile | 70386197.45 |
| Maximum | 73544841 |
| Range | 73474368 |
| Interquartile range | 47622318.25 |
Descriptive statistics
| Standard deviation | 24121476.52 |
|---|---|
| Coef of variation | 0.6890773042 |
| Kurtosis | -1.467026931 |
| Mean | 35005472.35 |
| MAD | 21732127.66 |
| Skewness | 0.01736816237 |
| Sum | 1.863789363e+13 |
| Variance | 5.818456293e+14 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 26216447 | 1 | < 0.1% | |
| 5308085 | 1 | < 0.1% | |
| 69615213 | 1 | < 0.1% | |
| 32908910 | 1 | < 0.1% | |
| 822758 | 1 | < 0.1% | |
| 53935733 | 1 | < 0.1% | |
| 57075318 | 1 | < 0.1% | |
| 46962149 | 1 | < 0.1% | |
| 71259567 | 1 | < 0.1% | |
| 9256974 | 1 | < 0.1% | |
| Other values (532418) | 532418 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 70473 | 1 | < 0.1% | |
| 70681 | 1 | < 0.1% | |
| 70694 | 1 | < 0.1% | |
| 70735 | 1 | < 0.1% | |
| 70978 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 73544841 | 1 | < 0.1% | |
| 73542831 | 1 | < 0.1% | |
| 73519894 | 1 | < 0.1% | |
| 73519746 | 1 | < 0.1% | |
| 73519699 | 1 | < 0.1% |
mths_since_last_delinq
Numeric
| Distinct count | 148 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 51.2% |
| Missing (n) | 272554 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 34.0557347 |
|---|---|
| Minimum | 0 |
| Maximum | 180 |
| Zeros (%) | 0.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 15 |
| Median | 31 |
| Q3 | 50 |
| 95-th percentile | 74 |
| Maximum | 180 |
| Range | 180 |
| Interquartile range | 35 |
Descriptive statistics
| Standard deviation | 21.88479738 |
|---|---|
| Coef of variation | 0.6426170973 |
| Kurtosis | -0.7640527973 |
| Mean | 34.0557347 |
| MAD | 18.48967387 |
| Skewness | 0.4555285283 |
| Sum | 8850200 |
| Variance | 478.9443564 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 9 | 5163 | 1.0% | |
| 6 | 5125 | 1.0% | |
| 12 | 5037 | 0.9% | |
| 7 | 5032 | 0.9% | |
| 13 | 5017 | 0.9% | |
| 8 | 4988 | 0.9% | |
| 10 | 4933 | 0.9% | |
| 15 | 4818 | 0.9% | |
| 14 | 4812 | 0.9% | |
| 11 | 4730 | 0.9% | |
| Other values (137) | 210219 | 39.5% | |
| (Missing) | 272554 | 51.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1025 | 0.2% | |
| 1 | 1967 | 0.4% | |
| 2 | 2405 | 0.5% | |
| 3 | 2900 | 0.5% | |
| 4 | 3572 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 180 | 1 | < 0.1% | |
| 176 | 1 | < 0.1% | |
| 171 | 1 | < 0.1% | |
| 170 | 2 | < 0.1% | |
| 159 | 1 | < 0.1% |
mths_since_last_major_derog
Numeric
| Distinct count | 163 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 75.0% |
| Missing (n) | 399448 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 44.12146187 |
|---|---|
| Minimum | 0 |
| Maximum | 180 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 27 |
| Median | 44 |
| Q3 | 61 |
| 95-th percentile | 77 |
| Maximum | 180 |
| Range | 180 |
| Interquartile range | 34 |
Descriptive statistics
| Standard deviation | 22.19840987 |
|---|---|
| Coef of variation | 0.5031204527 |
| Kurtosis | -0.02750251233 |
| Mean | 44.12146187 |
| MAD | 18.44583628 |
| Skewness | 0.26586312 |
| Sum | 5867272 |
| Variance | 492.7694008 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 45 | 2104 | 0.4% | |
| 46 | 2092 | 0.4% | |
| 42 | 2062 | 0.4% | |
| 43 | 2042 | 0.4% | |
| 37 | 2015 | 0.4% | |
| 48 | 1995 | 0.4% | |
| 38 | 1994 | 0.4% | |
| 44 | 1984 | 0.4% | |
| 40 | 1979 | 0.4% | |
| 47 | 1955 | 0.4% | |
| Other values (152) | 112758 | 21.2% | |
| (Missing) | 399448 | 75.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 84 | < 0.1% | |
| 1 | 370 | 0.1% | |
| 2 | 368 | 0.1% | |
| 3 | 412 | 0.1% | |
| 4 | 609 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 180 | 1 | < 0.1% | |
| 176 | 1 | < 0.1% | |
| 171 | 1 | < 0.1% | |
| 170 | 2 | < 0.1% | |
| 165 | 1 | < 0.1% |
mths_since_last_record
Numeric
| Distinct count | 123 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 84.6% |
| Missing (n) | 450305 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 70.09306772 |
|---|---|
| Minimum | 0 |
| Maximum | 121 |
| Zeros (%) | 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 51 |
| Median | 70 |
| Q3 | 92 |
| 95-th percentile | 114 |
| Maximum | 121 |
| Range | 121 |
| Interquartile range | 41 |
Descriptive statistics
| Standard deviation | 28.13921926 |
|---|---|
| Coef of variation | 0.4014550965 |
| Kurtosis | -0.5866892462 |
| Mean | 70.09306772 |
| MAD | 23.0328709 |
| Skewness | -0.2003172547 |
| Sum | 5756253 |
| Variance | 791.8156606 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 61 | 1180 | 0.2% | |
| 68 | 1166 | 0.2% | |
| 62 | 1157 | 0.2% | |
| 65 | 1156 | 0.2% | |
| 69 | 1156 | 0.2% | |
| 67 | 1156 | 0.2% | |
| 71 | 1151 | 0.2% | |
| 64 | 1133 | 0.2% | |
| 63 | 1123 | 0.2% | |
| 70 | 1115 | 0.2% | |
| Other values (112) | 70630 | 13.3% | |
| (Missing) | 450305 | 84.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 755 | 0.1% | |
| 1 | 45 | < 0.1% | |
| 2 | 36 | < 0.1% | |
| 3 | 71 | < 0.1% | |
| 4 | 95 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 121 | 2 | < 0.1% | |
| 120 | 8 | < 0.1% | |
| 119 | 531 | 0.1% | |
| 118 | 876 | 0.2% | |
| 117 | 898 | 0.2% |
open_acc
Numeric
| Distinct count | 74 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11.54559439 |
|---|---|
| Minimum | 0 |
| Maximum | 90 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| Median | 11 |
| Q3 | 14 |
| 95-th percentile | 21 |
| Maximum | 90 |
| Range | 90 |
| Interquartile range | 6 |
Descriptive statistics
| Standard deviation | 5.311442341 |
|---|---|
| Coef of variation | 0.4600406148 |
| Kurtosis | 3.170505953 |
| Mean | 11.54559439 |
| MAD | 4.063281959 |
| Skewness | 1.251513089 |
| Sum | 6147013 |
| Variance | 28.21141974 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 9 | 48345 | 9.1% | |
| 10 | 47212 | 8.9% | |
| 8 | 46065 | 8.7% | |
| 11 | 43384 | 8.1% | |
| 7 | 40501 | 7.6% | |
| 12 | 38666 | 7.3% | |
| 13 | 33986 | 6.4% | |
| 6 | 33532 | 6.3% | |
| 14 | 28771 | 5.4% | |
| 5 | 23935 | 4.5% | |
| Other values (63) | 148015 | 27.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 4 | < 0.1% | |
| 1 | 137 | < 0.1% | |
| 2 | 1654 | 0.3% | |
| 3 | 5741 | 1.1% | |
| 4 | 13991 | 2.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 1 | < 0.1% | |
| 84 | 1 | < 0.1% | |
| 82 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 76 | 1 | < 0.1% |
pub_rec
Numeric
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.194858493 |
|---|---|
| Minimum | 0 |
| Maximum | 86 |
| Zeros (%) | 84.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 86 |
| Range | 86 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.583822182 |
|---|---|
| Coef of variation | 2.996134132 |
| Kurtosis | 1337.011555 |
| Mean | 0.194858493 |
| MAD | 0.3301539962 |
| Skewness | 15.31822224 |
| Sum | 103745 |
| Variance | 0.3408483402 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 451040 | 84.7% | |
| 1 | 67938 | 12.8% | |
| 2 | 8841 | 1.7% | |
| 3 | 2692 | 0.5% | |
| 4 | 974 | 0.2% | |
| 5 | 424 | 0.1% | |
| 6 | 238 | < 0.1% | |
| 7 | 97 | < 0.1% | |
| 8 | 67 | < 0.1% | |
| 9 | 23 | < 0.1% | |
| Other values (18) | 78 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 451040 | 84.7% | |
| 1 | 67938 | 12.8% | |
| 2 | 8841 | 1.7% | |
| 3 | 2692 | 0.5% | |
| 4 | 974 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 86 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 49 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 28 | 1 | < 0.1% |
purpose
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| debt_consolidation | |
|---|---|
| credit_card | |
| home_improvement | 31087 |
| Other values (11) | 62682 |
| Value | Count | Frequency (%) | |
| debt_consolidation | 314989 | 59.2% | |
| credit_card | 123670 | 23.2% | |
| home_improvement | 31087 | 5.8% | |
| other | 25652 | 4.8% | |
| major_purchase | 10284 | 1.9% | |
| small_business | 6146 | 1.2% | |
| car | 5266 | 1.0% | |
| medical | 5117 | 1.0% | |
| moving | 3243 | 0.6% | |
| vacation | 2812 | 0.5% | |
| Other values (4) | 4162 | 0.8% |
| Max length | 18 |
|---|---|
| Mean length | 15.04095953 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
pymnt_plan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| n | |
|---|---|
| y | 8 |
| Value | Count | Frequency (%) | |
| n | 532420 | > 99.9% | |
| y | 8 | < 0.1% |
recoveries
Numeric
| Distinct count | 14024 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 45.7178317 |
|---|---|
| Minimum | 0 |
| Maximum | 33520.27 |
| Zeros (%) | 97.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 33520.27 |
| Range | 33520.27 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 409.6474671 |
|---|---|
| Coef of variation | 8.960343302 |
| Kurtosis | 624.6296143 |
| Mean | 45.7178317 |
| MAD | 89.02160815 |
| Skewness | 18.07600407 |
| Sum | 24341453.7 |
| Variance | 167811.0473 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 517723 | 97.2% | |
| 200 | 7 | < 0.1% | |
| 11.7 | 6 | < 0.1% | |
| 10.08 | 5 | < 0.1% | |
| 3000 | 5 | < 0.1% | |
| 13.2 | 5 | < 0.1% | |
| 10.2 | 5 | < 0.1% | |
| 1200 | 5 | < 0.1% | |
| 13.5 | 5 | < 0.1% | |
| 800 | 5 | < 0.1% | |
| Other values (14014) | 14657 | 2.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 517723 | 97.2% | |
| 0.25 | 1 | < 0.1% | |
| 2.34 | 1 | < 0.1% | |
| 3.6 | 1 | < 0.1% | |
| 6.3 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 33520.27 | 1 | < 0.1% | |
| 31900.52 | 1 | < 0.1% | |
| 29623.35 | 1 | < 0.1% | |
| 26308.47 | 1 | < 0.1% | |
| 23184.33 | 1 | < 0.1% |
revol_bal
Numeric
| Distinct count | 63459 |
|---|---|
| Unique (%) | 11.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16921.28032 |
|---|---|
| Minimum | 0 |
| Maximum | 2568995 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2023 |
| Q1 | 6444 |
| Median | 11876 |
| Q3 | 20843 |
| 95-th percentile | 43927 |
| Maximum | 2568995 |
| Range | 2568995 |
| Interquartile range | 14399 |
Descriptive statistics
| Standard deviation | 22423.21584 |
|---|---|
| Coef of variation | 1.32514889 |
| Kurtosis | 946.9518118 |
| Mean | 16921.28032 |
| MAD | 11410.54285 |
| Skewness | 15.98021197 |
| Sum | 9009363440 |
| Variance | 502800608.4 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 2017 | 0.4% | |
| 5235 | 52 | < 0.1% | |
| 5399 | 46 | < 0.1% | |
| 5466 | 45 | < 0.1% | |
| 5853 | 45 | < 0.1% | |
| 4136 | 44 | < 0.1% | |
| 7792 | 44 | < 0.1% | |
| 6189 | 44 | < 0.1% | |
| 5886 | 43 | < 0.1% | |
| 6052 | 43 | < 0.1% | |
| Other values (63449) | 530005 | 99.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2017 | 0.4% | |
| 1 | 33 | < 0.1% | |
| 2 | 23 | < 0.1% | |
| 3 | 32 | < 0.1% | |
| 4 | 23 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2568995 | 1 | < 0.1% | |
| 2560703 | 1 | < 0.1% | |
| 1746716 | 1 | < 0.1% | |
| 1743266 | 1 | < 0.1% | |
| 1190046 | 1 | < 0.1% |
revol_util
Numeric
| Distinct count | 1266 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.1% |
| Missing (n) | 287 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 55.05718917 |
|---|---|
| Minimum | 0 |
| Maximum | 892.3 |
| Zeros (%) | 0.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.8 |
| Q1 | 37.7 |
| Median | 56 |
| Q3 | 73.6 |
| 95-th percentile | 92.5 |
| Maximum | 892.3 |
| Range | 892.3 |
| Interquartile range | 35.9 |
Descriptive statistics
| Standard deviation | 23.8534365 |
|---|---|
| Coef of variation | 0.4332483525 |
| Kurtosis | 2.178742477 |
| Mean | 55.05718917 |
| MAD | 19.78202802 |
| Skewness | -0.08961858431 |
| Sum | 29298187.7 |
| Variance | 568.9864328 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 2137 | 0.4% | |
| 53 | 1124 | 0.2% | |
| 58 | 1082 | 0.2% | |
| 52 | 1054 | 0.2% | |
| 62 | 1047 | 0.2% | |
| 48 | 1045 | 0.2% | |
| 55 | 1040 | 0.2% | |
| 54 | 1023 | 0.2% | |
| 61 | 1021 | 0.2% | |
| 59 | 1018 | 0.2% | |
| Other values (1255) | 520550 | 97.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2137 | 0.4% | |
| 0.03 | 1 | < 0.1% | |
| 0.05 | 1 | < 0.1% | |
| 0.1 | 237 | < 0.1% | |
| 0.12 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 892.3 | 1 | < 0.1% | |
| 366.6 | 1 | < 0.1% | |
| 193 | 1 | < 0.1% | |
| 184.6 | 1 | < 0.1% | |
| 166.9 | 1 | < 0.1% |
sub_grade
Categorical
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| B3 | 33844 |
|---|---|
| B4 | 33198 |
| C1 | 31975 |
| Other values (32) |
| Value | Count | Frequency (%) | |
| B3 | 33844 | 6.4% | |
| B4 | 33198 | 6.2% | |
| C1 | 31975 | 6.0% | |
| C2 | 31356 | 5.9% | |
| C3 | 30080 | 5.6% | |
| B2 | 29390 | 5.5% | |
| B5 | 29313 | 5.5% | |
| C4 | 29103 | 5.5% | |
| A5 | 27016 | 5.1% | |
| B1 | 26968 | 5.1% | |
| Other values (25) | 230185 | 43.2% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
term
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 36 months | |
|---|---|
| 60 months |
| Value | Count | Frequency (%) | |
| 36 months | 372793 | 70.0% | |
| 60 months | 159635 | 30.0% |
| Max length | 9 |
|---|---|
| Mean length | 9 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
title
Categorical
| Distinct count | 39694 |
|---|---|
| Unique (%) | 7.5% |
| Missing (%) | < 0.1% |
| Missing (n) | 90 |
| Debt consolidation | |
|---|---|
| Credit card refinancing | |
| Home improvement | 24057 |
| Other values (39690) |
| Value | Count | Frequency (%) | |
| Debt consolidation | 248967 | 46.8% | |
| Credit card refinancing | 98582 | 18.5% | |
| Home improvement | 24057 | 4.5% | |
| Other | 19053 | 3.6% | |
| Debt Consolidation | 9932 | 1.9% | |
| Major purchase | 7195 | 1.4% | |
| Medical expenses | 3997 | 0.8% | |
| Business | 3962 | 0.7% | |
| Consolidation | 3354 | 0.6% | |
| Car financing | 3333 | 0.6% | |
| Other values (39683) | 109906 | 20.6% |
| Max length | 80 |
|---|---|
| Mean length | 17.72961602 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
tot_coll_amt
Numeric
| Distinct count | 8082 |
|---|---|
| Unique (%) | 1.5% |
| Missing (%) | 7.9% |
| Missing (n) | 42004 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 213.5622217 |
|---|---|
| Minimum | 0 |
| Maximum | 496651 |
| Zeros (%) | 79.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 634 |
| Maximum | 496651 |
| Range | 496651 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1958.571538 |
|---|---|
| Coef of variation | 9.170964429 |
| Kurtosis | 10577.26556 |
| Mean | 213.5622217 |
| MAD | 377.3924124 |
| Skewness | 61.64220691 |
| Sum | 104736039 |
| Variance | 3836002.471 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 420903 | 79.1% | |
| 50 | 1053 | 0.2% | |
| 100 | 815 | 0.2% | |
| 75 | 631 | 0.1% | |
| 150 | 418 | 0.1% | |
| 200 | 409 | 0.1% | |
| 60 | 392 | 0.1% | |
| 80 | 374 | 0.1% | |
| 70 | 349 | 0.1% | |
| 55 | 327 | 0.1% | |
| Other values (8071) | 64753 | 12.2% | |
| (Missing) | 42004 | 7.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 420903 | 79.1% | |
| 2 | 3 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 9 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 496651 | 1 | < 0.1% | |
| 296368 | 1 | < 0.1% | |
| 227157 | 1 | < 0.1% | |
| 169257 | 1 | < 0.1% | |
| 143558 | 1 | < 0.1% |
tot_cur_bal
Numeric
| Distinct count | 251641 |
|---|---|
| Unique (%) | 47.3% |
| Missing (%) | 7.9% |
| Missing (n) | 42004 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 139554.1108 |
|---|---|
| Minimum | 0 |
| Maximum | 8000078 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9217 |
| Q1 | 29839.75 |
| Median | 80669.5 |
| Q3 | 208479.25 |
| 95-th percentile | 424251.95 |
| Maximum | 8000078 |
| Range | 8000078 |
| Interquartile range | 178639.5 |
Descriptive statistics
| Standard deviation | 153914.8774 |
|---|---|
| Coef of variation | 1.102904648 |
| Kurtosis | 34.66750078 |
| Mean | 139554.1108 |
| MAD | 113658.531 |
| Skewness | 3.011754729 |
| Sum | 6.844068523e+10 |
| Variance | 2.36897895e+10 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 78 | < 0.1% | |
| 14511 | 17 | < 0.1% | |
| 5537 | 15 | < 0.1% | |
| 27316 | 15 | < 0.1% | |
| 19998 | 15 | < 0.1% | |
| 29232 | 14 | < 0.1% | |
| 22611 | 14 | < 0.1% | |
| 23346 | 14 | < 0.1% | |
| 23254 | 14 | < 0.1% | |
| 14535 | 14 | < 0.1% | |
| Other values (251630) | 490214 | 92.1% | |
| (Missing) | 42004 | 7.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 78 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 3 | < 0.1% | |
| 5 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8000078 | 1 | < 0.1% | |
| 4772549 | 1 | < 0.1% | |
| 4026405 | 1 | < 0.1% | |
| 3881449 | 1 | < 0.1% | |
| 3840795 | 1 | < 0.1% |
total_acc
Numeric
| Distinct count | 127 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 16 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.26735686 |
|---|---|
| Minimum | 1 |
| Maximum | 162 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 17 |
| Median | 24 |
| Q3 | 32 |
| 95-th percentile | 47 |
| Maximum | 162 |
| Range | 161 |
| Interquartile range | 15 |
Descriptive statistics
| Standard deviation | 11.84321082 |
|---|---|
| Coef of variation | 0.4687158568 |
| Kurtosis | 1.35541323 |
| Mean | 25.26735686 |
| MAD | 9.298095236 |
| Skewness | 0.8931946471 |
| Sum | 13452644 |
| Variance | 140.2616425 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 20 | 19338 | 3.6% | |
| 22 | 19266 | 3.6% | |
| 21 | 19099 | 3.6% | |
| 19 | 19056 | 3.6% | |
| 18 | 18738 | 3.5% | |
| 23 | 18703 | 3.5% | |
| 24 | 18623 | 3.5% | |
| 17 | 18536 | 3.5% | |
| 25 | 17846 | 3.4% | |
| 16 | 17448 | 3.3% | |
| Other values (116) | 345759 | 64.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 13 | < 0.1% | |
| 2 | 35 | < 0.1% | |
| 3 | 283 | 0.1% | |
| 4 | 1661 | 0.3% | |
| 5 | 2831 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 162 | 1 | < 0.1% | |
| 156 | 1 | < 0.1% | |
| 140 | 1 | < 0.1% | |
| 138 | 1 | < 0.1% | |
| 135 | 1 | < 0.1% |
total_rec_int
Numeric
| Distinct count | 243149 |
|---|---|
| Unique (%) | 45.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1753.428788 |
|---|---|
| Minimum | 0 |
| Maximum | 24205.62 |
| Zeros (%) | 2.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 80.19 |
| Q1 | 441.6 |
| Median | 1072.69 |
| Q3 | 2234.735 |
| 95-th percentile | 5889.503 |
| Maximum | 24205.62 |
| Range | 24205.62 |
| Interquartile range | 1793.135 |
Descriptive statistics
| Standard deviation | 2093.199837 |
|---|---|
| Coef of variation | 1.19377522 |
| Kurtosis | 11.64275416 |
| Mean | 1753.428788 |
| MAD | 1404.923078 |
| Skewness | 2.833204854 |
| Sum | 933574582.7 |
| Variance | 4381485.558 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 10953 | 2.1% | |
| 82.76 | 86 | < 0.1% | |
| 174.9 | 78 | < 0.1% | |
| 283.29 | 77 | < 0.1% | |
| 319.41 | 76 | < 0.1% | |
| 41.37 | 75 | < 0.1% | |
| 71.33 | 75 | < 0.1% | |
| 451.32 | 70 | < 0.1% | |
| 130.12 | 67 | < 0.1% | |
| 475.52 | 64 | < 0.1% | |
| Other values (243139) | 520807 | 97.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 10953 | 2.1% | |
| 0.01 | 7 | < 0.1% | |
| 0.56 | 1 | < 0.1% | |
| 0.59 | 1 | < 0.1% | |
| 0.62 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 24205.62 | 1 | < 0.1% | |
| 23450.38 | 1 | < 0.1% | |
| 23172.31 | 1 | < 0.1% | |
| 23171.65 | 1 | < 0.1% | |
| 22886.89 | 1 | < 0.1% |
total_rec_late_fee
Numeric
| Distinct count | 4073 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3949535031 |
|---|---|
| Minimum | 0 |
| Maximum | 358.68 |
| Zeros (%) | 98.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 358.68 |
| Range | 358.68 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.0915461 |
|---|---|
| Coef of variation | 10.35956402 |
| Kurtosis | 545.4515301 |
| Mean | 0.3949535031 |
| MAD | 0.7788762497 |
| Skewness | 17.68583522 |
| Sum | 210284.3037 |
| Variance | 16.74074949 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 0 | 524986 | 98.6% | |
| 15 | 1680 | 0.3% | |
| 30 | 219 | < 0.1% | |
| 45 | 31 | < 0.1% | |
| 18.87 | 10 | < 0.1% | |
| 16.37 | 10 | < 0.1% | |
| 18.02 | 9 | < 0.1% | |
| 20.6 | 9 | < 0.1% | |
| 16.84 | 9 | < 0.1% | |
| 20.5 | 9 | < 0.1% | |
| Other values (4063) | 5456 | 1.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 524986 | 98.6% | |
| 0.01 | 3 | < 0.1% | |
| 0.1017045619 | 1 | < 0.1% | |
| 0.1357656267 | 1 | < 0.1% | |
| 0.1800829035 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 358.68 | 1 | < 0.1% | |
| 294.68 | 1 | < 0.1% | |
| 252.8 | 1 | < 0.1% | |
| 229.75 | 1 | < 0.1% | |
| 213.3 | 1 | < 0.1% |
total_rev_hi_lim
Numeric
| Distinct count | 14698 |
|---|---|
| Unique (%) | 2.8% |
| Missing (%) | 7.9% |
| Missing (n) | 42004 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 32080.57292 |
|---|---|
| Minimum | 0 |
| Maximum | 9999999 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6000 |
| Q1 | 14000 |
| Median | 23700 |
| Q3 | 39800 |
| 95-th percentile | 83000 |
| Maximum | 9999999 |
| Range | 9999999 |
| Interquartile range | 25800 |
Descriptive statistics
| Standard deviation | 38053.03531 |
|---|---|
| Coef of variation | 1.18617069 |
| Kurtosis | 19273.88276 |
| Mean | 32080.57292 |
| MAD | 19614.31186 |
| Skewness | 77.3834345 |
| Sum | 1.573308289e+10 |
| Variance | 1448033496 |
| Memory size | 4.1 MiB |
| Value | Count | Frequency (%) | |
| 13500 | 1585 | 0.3% | |
| 14500 | 1576 | 0.3% | |
| 10000 | 1569 | 0.3% | |
| 12000 | 1564 | 0.3% | |
| 15000 | 1557 | 0.3% | |
| 14000 | 1536 | 0.3% | |
| 15500 | 1533 | 0.3% | |
| 13000 | 1532 | 0.3% | |
| 16500 | 1528 | 0.3% | |
| 12500 | 1525 | 0.3% | |
| Other values (14687) | 474919 | 89.2% | |
| (Missing) | 42004 | 7.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 161 | < 0.1% | |
| 100 | 4 | < 0.1% | |
| 200 | 5 | < 0.1% | |
| 300 | 46 | < 0.1% | |
| 400 | 23 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9999999 | 2 | < 0.1% | |
| 2013133 | 1 | < 0.1% | |
| 1998700 | 1 | < 0.1% | |
| 1314900 | 1 | < 0.1% | |
| 1200500 | 1 | < 0.1% |
verification_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Source Verified | |
|---|---|
| Verified | |
| Not Verified |
| Value | Count | Frequency (%) | |
| Source Verified | 197750 | 37.1% | |
| Verified | 174702 | 32.8% | |
| Not Verified | 159976 | 30.0% |
| Max length | 15 |
|---|---|
| Mean length | 11.80174221 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
verification_status_joint
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 99.9% |
| Missing (n) | 532123 |
| Not Verified | 170 |
|---|---|
| Verified | 102 |
| Source Verified | 33 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Not Verified | 170 | < 0.1% | |
| Verified | 102 | < 0.1% | |
| Source Verified | 33 | < 0.1% | |
| (Missing) | 532123 | 99.9% |
| Max length | 15 |
|---|---|
| Mean length | 3.004575267 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
zip_code
Categorical
| Distinct count | 917 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 945xx | 5845 |
|---|---|
| 750xx | 5680 |
| 112xx | 5632 |
| Other values (914) |
| Value | Count | Frequency (%) | |
| 945xx | 5845 | 1.1% | |
| 750xx | 5680 | 1.1% | |
| 112xx | 5632 | 1.1% | |
| 606xx | 5176 | 1.0% | |
| 300xx | 4757 | 0.9% | |
| 100xx | 4563 | 0.9% | |
| 900xx | 4500 | 0.8% | |
| 070xx | 4486 | 0.8% | |
| 331xx | 4475 | 0.8% | |
| 770xx | 4177 | 0.8% | |
| Other values (907) | 483137 | 90.7% |
| Max length | 5 |
|---|---|
| Mean length | 5 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
First rows
| acc_now_delinq | addr_state | annual_inc | application_type | batch_enrolled | collection_recovery_fee | collections_12_mths_ex_med | delinq_2yrs | desc | dti | emp_length | emp_title | funded_amnt | funded_amnt_inv | grade | home_ownership | initial_list_status | inq_last_6mths | int_rate | last_week_pay | loan_amnt | loan_status | member_id | mths_since_last_delinq | mths_since_last_major_derog | mths_since_last_record | open_acc | pub_rec | purpose | pymnt_plan | recoveries | revol_bal | revol_util | sub_grade | term | title | tot_coll_amt | tot_cur_bal | total_acc | total_rec_int | total_rec_late_fee | total_rev_hi_lim | verification_status | verification_status_joint | zip_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.0 | FL | 28700.0 | INDIVIDUAL | 0.0 | 0.0 | 0.0 | NaN | 33.88 | 9 years | clerk | 14350 | 14350.0 | E | OWN | f | 1.0 | 19.19 | 26th week | 14350 | 0 | 58189336 | 50.0 | 74.0 | 75.0 | 14.0 | 1.0 | debt_consolidation | n | 0.0 | 22515.0 | 73.1 | E3 | 36 months | Debt consolidation | 0.0 | 28699.0 | 28.0 | 1173.84 | 0.0 | 30800.0 | Source Verified | NaN | 349xx | |
| 1 | 0.0 | MD | 65000.0 | INDIVIDUAL | BAT1586599 | 0.0 | 0.0 | 0.0 | NaN | 3.64 | < 1 year | Human Resources Specialist | 4800 | 4800.0 | B | MORTGAGE | w | 1.0 | 10.99 | 9th week | 4800 | 0 | 70011223 | NaN | NaN | NaN | 6.0 | 0.0 | home_improvement | n | 0.0 | 7624.0 | 23.2 | B4 | 36 months | Home improvement | 0.0 | 9974.0 | 13.0 | 83.95 | 0.0 | 32900.0 | Source Verified | NaN | 209xx |
| 2 | 0.0 | OH | 45000.0 | INDIVIDUAL | BAT1586599 | 0.0 | 0.0 | 0.0 | NaN | 18.42 | 2 years | Driver | 10000 | 10000.0 | A | OWN | w | 0.0 | 7.26 | 9th week | 10000 | 0 | 70255675 | NaN | NaN | NaN | 5.0 | 0.0 | debt_consolidation | n | 0.0 | 10877.0 | 31.2 | A4 | 36 months | Debt consolidation | 65.0 | 38295.0 | 19.0 | 56.47 | 0.0 | 34900.0 | Not Verified | NaN | 447xx |
| 3 | 0.0 | VA | 105000.0 | INDIVIDUAL | BAT4808022 | 0.0 | 0.0 | 0.0 | > My goal is to obtain a loan to pay off my high credit cards and get out of debt within 3 years.<br> | 14.97 | 10+ years | Us office of Personnel Management | 15000 | 15000.0 | D | RENT | f | 2.0 | 19.72 | 135th week | 15000 | 0 | 1893936 | 46.0 | NaN | NaN | 10.0 | 0.0 | debt_consolidation | n | 0.0 | 13712.0 | 55.5 | D5 | 36 months | Debt consolidation | 0.0 | 55564.0 | 21.0 | 4858.62 | 0.0 | 24700.0 | Not Verified | NaN | 221xx |
| 4 | 0.0 | CA | 52000.0 | INDIVIDUAL | BAT2833642 | 0.0 | 0.0 | 0.0 | NaN | 20.16 | 10+ years | LAUSD-HOLLYWOOD HIGH SCHOOL | 16000 | 16000.0 | B | RENT | w | 0.0 | 10.64 | 96th week | 16000 | 0 | 7652106 | NaN | NaN | NaN | 11.0 | 0.0 | credit_card | n | 0.0 | 35835.0 | 76.2 | B2 | 36 months | refi | 0.0 | 47159.0 | 27.0 | 2296.41 | 0.0 | 47033.0 | Verified | NaN | 900xx |
| 5 | 0.0 | IN | 120000.0 | INDIVIDUAL | BAT2575549 | 0.0 | 0.0 | 0.0 | > We are requesting this loan to help re-organize our finances after having a tumultuous year that resulted in unexpected medical bills. I have been in the same line of work for over five years and have been at my current company, which is very stable in the marketplace, for two and a half years.<br> | 12.30 | 2 years | Design Consultant | 15000 | 14950.0 | A | MORTGAGE | f | 0.0 | 8.90 | 113th week | 15000 | 0 | 10247268 | 56.0 | NaN | NaN | 18.0 | 0.0 | debt_consolidation | n | 0.0 | 19040.0 | 64.5 | A5 | 36 months | Credit Card Debt Consolidation | 0.0 | 350619.0 | 30.0 | 1957.24 | 0.0 | 29500.0 | Not Verified | NaN | 461xx |
| 6 | 0.0 | CA | 75000.0 | INDIVIDUAL | 0.0 | 0.0 | 0.0 | > Funds will be used to pay off a debt. I am also a lender as well here on LC.<br> | 5.70 | 5 years | TOYOTA OF NORTH HOLLYWOOD | 5000 | 4975.0 | A | RENT | f | 0.0 | 7.90 | 117th week | 5000 | 1 | 8089625 | NaN | NaN | 105.0 | 13.0 | 2.0 | debt_consolidation | n | 0.0 | 13272.0 | 23.9 | A4 | 36 months | PAY THEM OFF | 1023.0 | 13272.0 | 23.0 | 578.36 | 0.0 | 55500.0 | Source Verified | NaN | 913xx | |
| 7 | 0.0 | AL | 54000.0 | INDIVIDUAL | NaN | 0.0 | 0.0 | 0.0 | NaN | 11.63 | 8 years | Banker | 6000 | 6000.0 | B | MORTGAGE | f | 1.0 | 9.17 | 78th week | 6000 | 0 | 23043116 | 46.0 | 54.0 | NaN | 13.0 | 0.0 | credit_card | n | 0.0 | 3484.0 | 29.5 | B1 | 36 months | Credit card refinancing | 0.0 | 272579.0 | 49.0 | 637.51 | 0.0 | 11800.0 | Not Verified | NaN | 351xx |
| 8 | 0.0 | CA | 92000.0 | INDIVIDUAL | BAT4136152 | 0.0 | 0.0 | 0.0 | NaN | 30.85 | 7 years | LVN | 6000 | 6000.0 | C | MORTGAGE | w | 0.0 | 13.99 | 44th week | 6000 | 0 | 45900933 | 77.0 | NaN | NaN | 16.0 | 0.0 | home_improvement | n | 0.0 | 47567.0 | 76.6 | C4 | 36 months | Home improvement | 0.0 | 281521.0 | 27.0 | 621.72 | 0.0 | 62100.0 | Not Verified | NaN | 917xx |
| 9 | 0.0 | KY | 72000.0 | INDIVIDUAL | BAT4694572 | 0.0 | 0.0 | 0.0 | NaN | 33.92 | 2 years | Registered Nurse | 34550 | 34550.0 | D | MORTGAGE | w | 0.0 | 17.14 | 52th week | 34550 | 0 | 41272507 | NaN | NaN | NaN | 12.0 | 0.0 | debt_consolidation | n | 0.0 | 30040.0 | 90.5 | D4 | 60 months | Debt consolidation | 0.0 | 76034.0 | 30.0 | 5535.46 | 0.0 | 33200.0 | Verified | NaN | 427xx |
Last rows
| acc_now_delinq | addr_state | annual_inc | application_type | batch_enrolled | collection_recovery_fee | collections_12_mths_ex_med | delinq_2yrs | desc | dti | emp_length | emp_title | funded_amnt | funded_amnt_inv | grade | home_ownership | initial_list_status | inq_last_6mths | int_rate | last_week_pay | loan_amnt | loan_status | member_id | mths_since_last_delinq | mths_since_last_major_derog | mths_since_last_record | open_acc | pub_rec | purpose | pymnt_plan | recoveries | revol_bal | revol_util | sub_grade | term | title | tot_coll_amt | tot_cur_bal | total_acc | total_rec_int | total_rec_late_fee | total_rev_hi_lim | verification_status | verification_status_joint | zip_code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 532418 | 0.0 | UT | 54000.0 | INDIVIDUAL | NaN | 0.0 | 0.0 | 0.0 | NaN | 25.07 | 9 years | Teacher | 10000 | 10000.0 | B | RENT | w | 0.0 | 9.76 | 4th week | 10000 | 0 | 71054913 | NaN | NaN | NaN | 11.0 | 0.0 | credit_card | n | 0.0 | 13856.0 | 70.3 | B3 | 36 months | Credit card refinancing | 890.0 | 121294.0 | 35.0 | 75.91 | 0.0 | 19700.0 | Source Verified | NaN | 840xx |
| 532419 | 0.0 | RI | 45000.0 | INDIVIDUAL | BAT1184694 | 0.0 | 0.0 | 1.0 | NaN | 7.97 | < 1 year | Help Desk Technician | 4800 | 4800.0 | B | RENT | w | 0.0 | 11.53 | 31th week | 4800 | 0 | 51774468 | 6.0 | NaN | NaN | 14.0 | 0.0 | credit_card | n | 0.0 | 4557.0 | 43.8 | B5 | 36 months | Credit card refinancing | 0.0 | 24985.0 | 23.0 | 308.18 | 0.0 | 10400.0 | Not Verified | NaN | 028xx |
| 532420 | 0.0 | PA | 37000.0 | INDIVIDUAL | BAT5489674 | 0.0 | 0.0 | 0.0 | NaN | 25.36 | 9 years | Admin Secretary | 5700 | 5700.0 | C | OWN | f | 3.0 | 14.16 | 4th week | 5700 | 1 | 16661491 | 49.0 | NaN | NaN | 10.0 | 0.0 | debt_consolidation | n | 0.0 | 9944.0 | 63.7 | C2 | 36 months | Debt consolidation | 0.0 | 89997.0 | 35.0 | 67.26 | 0.0 | 15600.0 | Source Verified | NaN | 178xx |
| 532421 | 0.0 | VA | 55000.0 | INDIVIDUAL | BAT2078974 | 0.0 | 0.0 | 1.0 | NaN | 4.65 | 3 years | Teacher | 13000 | 13000.0 | C | MORTGAGE | f | 0.0 | 12.99 | 65th week | 13000 | 0 | 32097538 | 7.0 | 7.0 | NaN | 11.0 | 0.0 | debt_consolidation | n | 0.0 | 6638.0 | 24.7 | C1 | 60 months | Debt consolidation | 0.0 | 11231.0 | 25.0 | 1916.77 | 0.0 | 26900.0 | Source Verified | NaN | 239xx |
| 532422 | 0.0 | WA | 49900.0 | INDIVIDUAL | NaN | 0.0 | 0.0 | 0.0 | NaN | 20.20 | 10+ years | Champion Mortgage | 10000 | 10000.0 | C | MORTGAGE | w | 1.0 | 14.33 | 22th week | 10000 | 1 | 8219842 | NaN | NaN | NaN | 13.0 | 0.0 | debt_consolidation | n | 0.0 | 14510.0 | 60.0 | C2 | 36 months | Consolidation | 0.0 | 189233.0 | 17.0 | 569.12 | 0.0 | 24200.0 | Source Verified | NaN | 984xx |
| 532423 | 0.0 | MI | 75000.0 | INDIVIDUAL | 0.0 | 0.0 | 0.0 | NaN | 14.53 | 10+ years | Registered Nurse | 20000 | 20000.0 | B | MORTGAGE | f | 0.0 | 12.49 | 65th week | 20000 | 0 | 31296187 | NaN | NaN | 51.0 | 12.0 | 1.0 | debt_consolidation | n | 0.0 | 15775.0 | 63.6 | B5 | 36 months | Debt consolidation | 0.0 | 83087.0 | 34.0 | 2595.45 | 0.0 | 24800.0 | Source Verified | NaN | 481xx | |
| 532424 | 0.0 | MI | 59000.0 | INDIVIDUAL | BAT2003848 | 0.0 | 0.0 | 0.0 | NaN | 22.97 | 10+ years | Account Mgr | 12000 | 12000.0 | C | MORTGAGE | w | 0.0 | 14.99 | 70th week | 12000 | 0 | 29403184 | NaN | NaN | 81.0 | 10.0 | 1.0 | debt_consolidation | n | 0.0 | 9453.0 | 53.1 | C5 | 60 months | Debt consolidation | 0.0 | 227812.0 | 29.0 | 2182.92 | 0.0 | 17800.0 | Not Verified | NaN | 496xx |
| 532425 | 0.0 | TN | 42504.0 | INDIVIDUAL | NaN | 0.0 | 0.0 | 0.0 | NaN | 27.27 | 8 years | Comcast cable | 18725 | 18725.0 | E | RENT | f | 1.0 | 20.80 | 9th week | 18725 | 1 | 7357607 | 26.0 | NaN | NaN | 14.0 | 0.0 | debt_consolidation | n | 0.0 | 12085.0 | 49.9 | E1 | 60 months | Debt consolidation | 0.0 | 26010.0 | 26.0 | 645.32 | 0.0 | 24200.0 | Verified | NaN | 370xx |
| 532426 | 0.0 | OH | 50000.0 | INDIVIDUAL | BAT3193689 | 0.0 | 0.0 | 0.0 | NaN | 14.91 | 1 year | Resident Physician | 21000 | 21000.0 | D | RENT | w | 1.0 | 16.29 | 78th week | 21000 | 0 | 23182668 | NaN | NaN | NaN | 7.0 | 0.0 | credit_card | n | 0.0 | 20902.0 | 89.7 | D2 | 60 months | Credit card refinancing | 0.0 | 29197.0 | 14.0 | 4619.79 | 0.0 | 23300.0 | Source Verified | NaN | 432xx |
| 532427 | 0.0 | CA | 53000.0 | INDIVIDUAL | BAT4136152 | 0.0 | 0.0 | 0.0 | NaN | 17.80 | < 1 year | Health Care Analyst | 10000 | 10000.0 | A | RENT | f | 0.0 | 6.39 | 44th week | 10000 | 0 | 46122259 | NaN | NaN | NaN | 11.0 | 0.0 | debt_consolidation | n | 0.0 | 10058.0 | 46.4 | A2 | 36 months | Debt consolidation | 0.0 | 47866.0 | 20.0 | 467.52 | 0.0 | 21700.0 | Not Verified | NaN | 956xx |